How to install SQL server 2017| 2021 - SQL Server Installation Guide Step by Step

About MS(Microsoft) SQL Server

MS SQL Server is RDBMS (Relational Database Management System) Developed by Microsoft. Generally work of it is to storing and retrieving data (as per request i.e. Web API, Controller, etc.)

Types of Download

There are mainly two types of versions available

Free

1. Developer
2. Express



Paid

1. SQL Server on Azure
2. SQL Server at the edge
3. SQL Server on-premises

Steps to Download

To Download MS SQL Server First Search on Google "download Microsoft SQL server" OR you can simply visit this Official Link from Microsoft https://www.microsoft.com/en-in/sql-server/sql-server-downloads.

1. The Installer will downloaded. Double Click on Installer to Start Installation. Choose the Custom Option and Click Install as shown in below Image.
   
2. In Next window Choose the location of your choice and click on install. Before Click on Install Make Sure You are connected to internet. It will Download and install the required files.
   
3. After Download Complete It will open new window SQL Server Installation Center Click on Installation from the left panel in window than after choose New SQL Server stand-alone installation or add feature to existing installation
   
   
   
   
4. When You Click on New SQL Server stand-alone installation or add feature to existing installation It will take you to another new window SQL Server 2017 Setup In that window just keep the settings as it is and click the next button.
   
   
   
   
5. than Accept agreement and click on next
   
   
   
   
6. After accept the agreement just wait for it complete the installation. It should Look like the Image Below than click on Next Button
   
   
   
   
7. You will See the Feature Selection Window. Here You can select the Feature of your choice My Choice is Database Engine Service Select Your requirement and click the next button
   
   
   
   
8. After you complete the Feature Selection You will be taken to the Instance Configuration Window, Here You can name your choice Instance and Click Next that will take yo to the Server Configuration Tab, Here Simple Click Next.
   
   
   
   
9. Database Engine Cofiguration next part you have to choose your password if you will go for mixed mode authentication. and Click Add Current User Button to add the User and Click Next Note: Remember Default Id for Log in to your server will be sa
   
   
   
10. After You Follow all the Steps Lastly You will have the Message Successful Install as the image below.
    
    
    
11. At Next We have to install SQL Server Management Studio
    Close the SQL Server 2017 Setup Window and return to SQL Server Installation Center . Choose Install SQL Server Management Tools from the right Panel
    
    
    
    You will be redirected to the Microsoft's Website Click on Download SQL Server Management Studio (SSMS) Executable file will be downloaded.
    
    
    
12. After Download Complete Click on the file which is downloaded. and click Install.
    
    
    
13. You will get Successful installation message as shown below.
    
    
    

I hope after following all the steps you got the correct setup on your machine Please Comment Below if you face any issues.